Root Zanli
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
o5t6x7pgljbm
/
public_html
/
admin
/
storage
/
logs
/
Filename :
laravel-2025-09-03.log
back
Copy
[2025-09-03 04:30:54] local.INFO: V2ChildController::getUserDashboardForApp() [2025-09-03 04:30:54] local.INFO: V2ChildController::getFilteredTasks() [2025-09-03 04:30:54] local.DEBUG: Task Sql:select `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` left join `task_visibility` on `task_visibility`.`task_settings_id` = `task_settings`.`task_settings_id` left join `task_visibility` as `visibility_country_single` on `visibility_country_single`.`task_settings_id` = `visibility_country_single`.`task_settings_id` and `visibility_country_single`.`entity_type` = 'COUNTRY_SINGLE' left join `task_assigned` on `tasks`.`task_id` = `task_assigned`.`task_id` and `task_assigned`.`user_id` = ? and `task_assigned`.`group_id` = ? where (`task_assigned`.`user_id` is not null or (`task_settings`.`visible_to` in (?) and `task_visibility`.`entity_type` = ? and `task_visibility`.`entity_value` is null and `visibility_country_single`.`entity_value` is null) or (`task_settings`.`visible_to` in (?, ?))) and (`tasks`.`due_by` > '2025-09-03' or `tasks`.`due_by` is null) and `tasks`.`deleted_at` is null group by `tasks`.`task_id` order by `task_assigned`.`user_id` desc, `task_id` desc limit 1 [2025-09-03 04:30:54] local.DEBUG: Values for Sql:Array ( [0] => 312 [1] => 220 [2] => ZIPCODE_PARENT_AND_CHILD [3] => ZIPCODE [4] => GLOBAL [5] => GLOBAL_FOR_PARENT_AND_CHILD ) [2025-09-03 04:30:54] local.INFO: V2ChildController::getFilteredRewards() [2025-09-03 04:30:54] local.INFO: child if condition before CHILD [2025-09-03 04:30:54] local.INFO: child if condition after [2025-09-03 04:30:54] local.DEBUG: SQL to get Rewards: select `products`.* from `products` left join `store_product` on `store_product`.`product_id` = `products`.`product_id` and `store_product`.`deleted_at` IS NULL left join `reward_settings` on `reward_settings`.`reward_id` = `products`.`product_id` left join `reward_visibility` on `reward_visibility`.`reward_settings_id` = `reward_settings`.`reward_settings_id` where ((`reward_settings`.`visible_to` in (?) and `reward_settings`.`visible_in_family_store` = ? and `store_product`.`store_id` = ? and `store_product`.`is_published` = ?) or (`reward_settings`.`visible_to` in (?) and `products`.`group_id` = ?) or (`store_product`.`store_id` = ? and `store_product`.`is_published` <=> ?)) and `products`.`deleted_at` is null group by `products`.`product_id` order by `products`.`created_at` desc limit 1 [2025-09-03 04:30:54] local.DEBUG: Values for Sql:Array ( [0] => GLOBAL_FOR_PARENT [1] => 1 [2] => 218 [3] => 1 [4] => SINGLE_GROUP [5] => 220 [6] => 218 [7] => 0 ) [2025-09-03 04:30:54] local.DEBUG: Task Sql:select `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` where `tasks`.`product_id` in (?) and `tasks`.`deleted_at` is null group by `tasks`.`task_id` order by `created_at` desc [2025-09-03 04:30:54] local.DEBUG: Values for Sql:Array ( [0] => 358 ) [2025-09-03 04:31:03] local.INFO: V2ChildController::getUserDashboardForApp() [2025-09-03 04:31:03] local.INFO: V2ChildController::getHasNewActivity() [2025-09-03 04:31:06] local.INFO: V2ChildController::update_children_attendance() [2025-09-03 04:31:06] local.DEBUG: Allocating SP [2025-09-03 04:31:06] local.INFO: V2ChildController::getUserDashboardForApp() [2025-09-03 04:31:06] local.INFO: V2ChildController::getFilteredTasks() [2025-09-03 04:31:06] local.DEBUG: Task Sql:select `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` left join `task_visibility` on `task_visibility`.`task_settings_id` = `task_settings`.`task_settings_id` left join `task_visibility` as `visibility_country_single` on `visibility_country_single`.`task_settings_id` = `visibility_country_single`.`task_settings_id` and `visibility_country_single`.`entity_type` = 'COUNTRY_SINGLE' left join `task_assigned` on `tasks`.`task_id` = `task_assigned`.`task_id` and `task_assigned`.`user_id` = ? and `task_assigned`.`group_id` = ? where (`task_assigned`.`user_id` is not null or (`task_settings`.`visible_to` in (?) and `task_visibility`.`entity_type` = ? and `task_visibility`.`entity_value` is null and `visibility_country_single`.`entity_value` is null) or (`task_settings`.`visible_to` in (?, ?))) and (`tasks`.`due_by` > '2025-09-03' or `tasks`.`due_by` is null) and `tasks`.`deleted_at` is null group by `tasks`.`task_id` order by `task_assigned`.`user_id` desc, `task_id` desc limit 1 [2025-09-03 04:31:06] local.DEBUG: Values for Sql:Array ( [0] => 312 [1] => 220 [2] => ZIPCODE_PARENT_AND_CHILD [3] => ZIPCODE [4] => GLOBAL [5] => GLOBAL_FOR_PARENT_AND_CHILD ) [2025-09-03 04:31:06] local.INFO: V2ChildController::getFilteredRewards() [2025-09-03 04:31:06] local.INFO: child if condition before CHILD [2025-09-03 04:31:06] local.INFO: child if condition after [2025-09-03 04:31:06] local.DEBUG: SQL to get Rewards: select `products`.* from `products` left join `store_product` on `store_product`.`product_id` = `products`.`product_id` and `store_product`.`deleted_at` IS NULL left join `reward_settings` on `reward_settings`.`reward_id` = `products`.`product_id` left join `reward_visibility` on `reward_visibility`.`reward_settings_id` = `reward_settings`.`reward_settings_id` where ((`reward_settings`.`visible_to` in (?) and `reward_settings`.`visible_in_family_store` = ? and `store_product`.`store_id` = ? and `store_product`.`is_published` = ?) or (`reward_settings`.`visible_to` in (?) and `products`.`group_id` = ?) or (`store_product`.`store_id` = ? and `store_product`.`is_published` <=> ?)) and `products`.`deleted_at` is null group by `products`.`product_id` order by `products`.`created_at` desc limit 1 [2025-09-03 04:31:06] local.DEBUG: Values for Sql:Array ( [0] => GLOBAL_FOR_PARENT [1] => 1 [2] => 218 [3] => 1 [4] => SINGLE_GROUP [5] => 220 [6] => 218 [7] => 0 ) [2025-09-03 04:31:06] local.DEBUG: Task Sql:select `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` where `tasks`.`product_id` in (?) and `tasks`.`deleted_at` is null group by `tasks`.`task_id` order by `created_at` desc [2025-09-03 04:31:06] local.DEBUG: Values for Sql:Array ( [0] => 358 ) [2025-09-03 04:31:14] local.INFO: V2ChildController::getHasNewActivity() [2025-09-03 07:05:03] local.DEBUG: Tasks to be repeated SQL: select `tasks`.`task_id`, `tasks`.* from `tasks` left join `task_settings` on `tasks`.`task_id` = `task_settings`.`task_id` where MOD(DATEDIFF(CURRENT_DATE, tasks.created_at), task_settings.repeate_after_days) = 0 and `tasks`.`is_repeated` = ? and `tasks`.`due_by` >= CURRENT_DATE and `tasks`.`deleted_at` is null [2025-09-03 07:05:03] local.DEBUG: Response: Array ( [Code] => 200 [Message] => No tasks to be repeated today )